SEAI Data Report v2

Dataset statistics

Number of variables	16
Number of observations	1043910
Missing cells	1105819
Missing cells (%)	6.6%
Duplicate rows	5325
Duplicate rows (%)	0.5%
Total size in memory	733.3 MiB
Average record size in memory	736.6 B

Variable types

Categorical	10
Numeric	6

Alerts

Dataset has 5325 (0.5%) duplicate rows	Duplicates
`CountyName` has a high cardinality: 55 distinct values	High cardinality
`DateOfAssessment` has a high cardinality: 5282 distinct values	High cardinality
`YearofConstruction` is highly correlated with `BerRating` and 1 other fields	High correlation
`BerRating` is highly correlated with `YearofConstruction` and 1 other fields	High correlation
`GroundFloorArea(sq m)` is highly correlated with `TotalDeliveredEnergy`	High correlation
`CO2Rating` is highly correlated with `YearofConstruction` and 2 other fields	High correlation
`TotalDeliveredEnergy` is highly correlated with `GroundFloorArea(sq m)` and 1 other fields	High correlation
`YearofConstruction` is highly correlated with `BerRating`	High correlation
`BerRating` is highly correlated with `YearofConstruction` and 2 other fields	High correlation
`CO2Rating` is highly correlated with `BerRating` and 1 other fields	High correlation
`TotalDeliveredEnergy` is highly correlated with `BerRating` and 1 other fields	High correlation
`YearofConstruction` is highly correlated with `BerRating` and 1 other fields	High correlation
`BerRating` is highly correlated with `YearofConstruction` and 1 other fields	High correlation
`CO2Rating` is highly correlated with `YearofConstruction` and 1 other fields	High correlation
`MainSpaceHeatingFuel` is highly correlated with `MainWaterHeatingFuel`	High correlation
`MainWaterHeatingFuel` is highly correlated with `MainSpaceHeatingFuel`	High correlation
`CountyName` is highly correlated with `DwellingTypeDescr` and 2 other fields	High correlation
`DwellingTypeDescr` is highly correlated with `CountyName`	High correlation
`YearofConstruction` is highly correlated with `EnergyRating`	High correlation
`EnergyRating` is highly correlated with `YearofConstruction` and 3 other fields	High correlation
`BerRating` is highly correlated with `CO2Rating` and 1 other fields	High correlation
`CO2Rating` is highly correlated with `BerRating` and 1 other fields	High correlation
`MainSpaceHeatingFuel` is highly correlated with `CountyName` and 1 other fields	High correlation
`MainWaterHeatingFuel` is highly correlated with `CountyName` and 1 other fields	High correlation
`VentilationMethod` is highly correlated with `EnergyRating`	High correlation
`StructureType` is highly correlated with `EnergyRating`	High correlation
`InsulationType` is highly correlated with `EnergyRating`	High correlation
`TotalDeliveredEnergy` is highly correlated with `BerRating` and 1 other fields	High correlation
`MainSpaceHeatingFuel` has 15648 (1.5%) missing values	Missing
`MainWaterHeatingFuel` has 15648 (1.5%) missing values	Missing
`InsulationType` has 232787 (22.3%) missing values	Missing
`InsulationThickness` has 232787 (22.3%) missing values	Missing
`TotalDeliveredEnergy` has 598110 (57.3%) missing values	Missing
`BerRating` is highly skewed (γ1 = 51.73654348)	Skewed
`CO2Rating` is highly skewed (γ1 = 68.08527183)	Skewed
`TotalDeliveredEnergy` is highly skewed (γ1 = 87.22682973)	Skewed
`InsulationThickness` has 128896 (12.3%) zeros	Zeros

Reproduction

Analysis started	2022-07-20 22:28:21.343380
Analysis finished	2022-07-20 22:29:08.164647
Duration	46.82 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

CountyName
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct	55
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	66.6 MiB

Co. Cork	94961
Co. Dublin	80411
Co. Kildare	47843
Co. Meath	41047
Co. Galway	40009
Other values (50)	739639

Length

Max length	14
Median length	13
Mean length	9.867811401
Min length	8

Characters and Unicode

Total characters	10301107
Distinct characters	46
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Co. Donegal
2nd row	Co. Kildare
3rd row	Co. Dublin
4th row	Dublin 11
5th row	Dublin 22

Common Values

Value	Count	Frequency (%)
Co. Cork	94961	9.1%
Co. Dublin	80411	7.7%
Co. Kildare	47843	4.6%
Co. Meath	41047	3.9%
Co. Galway	40009	3.8%
Co. Wexford	34283	3.3%
Co. Kerry	32755	3.1%
Co. Tipperary	32565	3.1%
Co. Wicklow	31870	3.1%
Co. Donegal	31717	3.0%
Other values (45)	576449	55.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
co	741717	35.5%
dublin	313810	15.0%
cork	117311	5.6%
city	68794	3.3%
galway	56026	2.7%
kildare	47843	2.3%
limerick	44677	2.1%
meath	41047	2.0%
wexford	34283	1.6%
kerry	32755	1.6%
Other values (43)	589557	28.2%

Most occurring characters

Value	Count	Frequency (%)
o	1152923	11.2%
	1043910	10.1%
C	982411	9.5%
.	741717	7.2%
i	648791	6.3%
l	567063	5.5%
r	485924	4.7%
a	458380	4.4%
n	436114	4.2%
e	379830	3.7%
Other values (36)	3404044	33.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	6289600	61.1%
Uppercase Letter	1860018	18.1%
Space Separator	1043910	10.1%
Other Punctuation	741717	7.2%
Decimal Number	365862	3.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	1152923	18.3%
i	648791	10.3%
l	567063	9.0%
r	485924	7.7%
a	458380	7.3%
n	436114	6.9%
e	379830	6.0%
u	343657	5.5%
b	313810	5.0%
y	248387	3.9%
Other values (13)	1254721	19.9%

Uppercase Letter

Value	Count	Frequency (%)
C	982411	52.8%
D	345527	18.6%
W	117704	6.3%
L	107620	5.8%
K	97447	5.2%
M	78586	4.2%
G	56026	3.0%
T	32565	1.8%
S	15811	0.9%
O	13836	0.7%

Decimal Number

Value	Count	Frequency (%)
1	125110	34.2%
2	55729	15.2%
4	40890	11.2%
5	34468	9.4%
8	28666	7.8%
6	25277	6.9%
3	18567	5.1%
7	17704	4.8%
9	12512	3.4%
0	6939	1.9%

Space Separator

Value	Count	Frequency (%)
	1043910	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	741717	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8149618	79.1%
Common	2151489	20.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	1152923	14.1%
C	982411	12.1%
i	648791	8.0%
l	567063	7.0%
r	485924	6.0%
a	458380	5.6%
n	436114	5.4%
e	379830	4.7%
D	345527	4.2%
u	343657	4.2%
Other values (24)	2348998	28.8%

Common

Value	Count	Frequency (%)
	1043910	48.5%
.	741717	34.5%
1	125110	5.8%
2	55729	2.6%
4	40890	1.9%
5	34468	1.6%
8	28666	1.3%
6	25277	1.2%
3	18567	0.9%
7	17704	0.8%
Other values (2)	19451	0.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10301107	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	1152923	11.2%
	1043910	10.1%
C	982411	9.5%
.	741717	7.2%
i	648791	6.3%
l	567063	5.5%
r	485924	4.7%
a	458380	4.4%
n	436114	4.2%
e	379830	3.7%
Other values (36)	3404044	33.0%

DwellingTypeDescr
Categorical

HIGH CORRELATION

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	73.6 MiB

Detached house	293509
Semi-detached house	286024
Mid-terrace house	148536
End of terrace house	80130
Mid-floor apartment	71142
Other values (6)	164569

Length

Max length	22
Median length	20
Mean length	16.95907023
Min length	5

Characters and Unicode

Total characters	17703743
Distinct characters	29
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Detached house
2nd row	Detached house
3rd row	Semi-detached house
4th row	Semi-detached house
5th row	Semi-detached house

Common Values

Value	Count	Frequency (%)
Detached house	293509	28.1%
Semi-detached house	286024	27.4%
Mid-terrace house	148536	14.2%
End of terrace house	80130	7.7%
Mid-floor apartment	71142	6.8%
Top-floor apartment	58379	5.6%
Ground-floor apartment	56706	5.4%
House	33950	3.3%
Maisonette	11822	1.1%
Apartment	3382	0.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
house	842149	38.3%
detached	293509	13.3%
semi-detached	286024	13.0%
apartment	189609	8.6%
mid-terrace	148536	6.8%
end	80130	3.6%
of	80130	3.6%
terrace	80130	3.6%
mid-floor	71142	3.2%
top-floor	58379	2.7%
Other values (4)	69188	3.1%

Most occurring characters

Value	Count	Frequency (%)
e	2958814	16.7%
o	1421640	8.0%
h	1387732	7.8%
d	1222071	6.9%
t	1211391	6.8%
a	1196187	6.8%
	1155016	6.5%
u	898855	5.1%
r	889874	5.0%
s	854301	4.8%
Other values (19)	4507862	25.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	14883700	84.1%
Space Separator	1155016	6.5%
Uppercase Letter	1044240	5.9%
Dash Punctuation	620787	3.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	2958814	19.9%
o	1421640	9.6%
h	1387732	9.3%
d	1222071	8.2%
t	1211391	8.1%
a	1196187	8.0%
u	898855	6.0%
r	889874	6.0%
s	854301	5.7%
c	808199	5.4%
Other values (8)	2034636	13.7%

Uppercase Letter

Value	Count	Frequency (%)
D	293839	28.1%
S	286024	27.4%
M	231500	22.2%
E	80130	7.7%
T	58379	5.6%
G	56706	5.4%
H	33950	3.3%
A	3382	0.3%
B	330	< 0.1%

Space Separator

Value	Count	Frequency (%)
	1155016	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	620787	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	15927940	90.0%
Common	1775803	10.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	2958814	18.6%
o	1421640	8.9%
h	1387732	8.7%
d	1222071	7.7%
t	1211391	7.6%
a	1196187	7.5%
u	898855	5.6%
r	889874	5.6%
s	854301	5.4%
c	808199	5.1%
Other values (17)	3078876	19.3%

Common

Value	Count	Frequency (%)
	1155016	65.0%
-	620787	35.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	17703743	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	2958814	16.7%
o	1421640	8.0%
h	1387732	7.8%
d	1222071	6.9%
t	1211391	6.8%
a	1196187	6.8%
	1155016	6.5%
u	898855	5.1%
r	889874	5.0%
s	854301	4.8%
Other values (19)	4507862	25.5%

YearofConstruction
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	267
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1983.789112

Minimum	1753
Maximum	2104
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.0 MiB

Quantile statistics

Minimum	1753
5-th percentile	1900
Q1	1973
median	1997
Q3	2005
95-th percentile	2019
Maximum	2104
Range	351
Interquartile range (IQR)	32

Descriptive statistics

Standard deviation	33.78415428
Coefficient of variation (CV)	0.01703011377
Kurtosis	3.932625529
Mean	1983.789112
Median Absolute Deviation (MAD)	12
Skewness	-1.815695191
Sum	2070897292
Variance	1141.36908
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2006	51793	5.0%
2004	48399	4.6%
2005	47419	4.5%
2007	40429	3.9%
2003	39650	3.8%
2002	33077	3.2%
1900	31000	3.0%
2000	29573	2.8%
2001	25570	2.4%
1998	24319	2.3%
Other values (257)	672681	64.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1753	14	< 0.1%
1757	1	< 0.1%
1759	3	< 0.1%
1760	224	< 0.1%
1761	8	< 0.1%
1762	1	< 0.1%
1764	1	< 0.1%
1765	5	< 0.1%
1766	1	< 0.1%
1767	2	< 0.1%

Value	Count	Frequency (%)
2104	1	< 0.1%
2073	1	< 0.1%
2033	1	< 0.1%
2029	1	< 0.1%
2024	1	< 0.1%
2023	1	< 0.1%
2022	6643	0.6%
2021	13620	1.3%
2020	17480	1.7%
2019	22155	2.1%

EnergyRating
Categorical

HIGH CORRELATION

Distinct	15
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	58.7 MiB

C2	126621
C3	119711
C1	116607
D1	115760
D2	99524
Other values (10)	465687

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	2087820
Distinct characters	11
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	C2
2nd row	B3
3rd row	C3
4th row	C2
5th row	D2

Common Values

Value	Count	Frequency (%)
C2	126621	12.1%
C3	119711	11.5%
C1	116607	11.2%
D1	115760	11.1%
D2	99524	9.5%
B3	81540	7.8%
G	67179	6.4%
A3	59647	5.7%
E1	57450	5.5%
A2	53402	5.1%
Other values (5)	146469	14.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
c2	126621	12.1%
c3	119711	11.5%
c1	116607	11.2%
d1	115760	11.1%
d2	99524	9.5%
b3	81540	7.8%
g	67179	6.4%
a3	59647	5.7%
e1	57450	5.5%
a2	53402	5.1%
Other values (5)	146469	14.0%

Most occurring characters

Value	Count	Frequency (%)
C	362939	17.4%
2	360989	17.3%
1	308141	14.8%
3	260898	12.5%
D	215284	10.3%
B	134495	6.4%
A	114428	5.5%
	113882	5.5%
E	102882	4.9%
G	67179	3.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1043910	50.0%
Decimal Number	930028	44.5%
Space Separator	113882	5.5%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	362939	34.8%
D	215284	20.6%
B	134495	12.9%
A	114428	11.0%
E	102882	9.9%
G	67179	6.4%
F	46703	4.5%

Decimal Number

Value	Count	Frequency (%)
2	360989	38.8%
1	308141	33.1%
3	260898	28.1%

Space Separator

Value	Count	Frequency (%)
	113882	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1043910	50.0%
Common	1043910	50.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	362939	34.8%
D	215284	20.6%
B	134495	12.9%
A	114428	11.0%
E	102882	9.9%
G	67179	6.4%
F	46703	4.5%

Common

Value	Count	Frequency (%)
2	360989	34.6%
1	308141	29.5%
3	260898	25.0%
	113882	10.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2087820	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
C	362939	17.4%
2	360989	17.3%
1	308141	14.8%
3	260898	12.5%
D	215284	10.3%
B	134495	6.4%
A	114428	5.5%
	113882	5.5%
E	102882	4.9%
G	67179	3.2%

BerRating
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	77722
Distinct (%)	7.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	234.5496591

Minimum	-158.42
Maximum	56423.71
Zeros	0
Zeros (%)	0.0%
Negative	161
Negative (%)	< 0.1%
Memory size	8.0 MiB

Quantile statistics

Minimum	-158.42
5-th percentile	49.31
Q1	153.64
median	207.08
Q3	282.32
95-th percentile	492.23
Maximum	56423.71
Range	56582.13
Interquartile range (IQR)	128.68

Descriptive statistics

Standard deviation	172.7810331
Coefficient of variation (CV)	0.7366501138
Kurtosis	13357.81442
Mean	234.5496591
Median Absolute Deviation (MAD)	61.51
Skewness	51.73654348
Sum	244848734.6
Variance	29853.28538
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
224.56	105	< 0.1%
181.97	96	< 0.1%
224.87	93	< 0.1%
224.85	93	< 0.1%
224.95	91	< 0.1%
55.98	91	< 0.1%
224.63	90	< 0.1%
174.81	89	< 0.1%
199.92	89	< 0.1%
212.52	88	< 0.1%
Other values (77712)	1042985	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-158.42	1	< 0.1%
-97.37	1	< 0.1%
-63.96	1	< 0.1%
-60.97	1	< 0.1%
-56.06	1	< 0.1%
-49.16	1	< 0.1%
-48.01	1	< 0.1%
-45.32	1	< 0.1%
-44.66	1	< 0.1%
-43.64	1	< 0.1%

Value	Count	Frequency (%)
56423.71	1	< 0.1%
32134.94	1	< 0.1%
31623.33	1	< 0.1%
21725.62	1	< 0.1%
18771.31	1	< 0.1%
13914.78	1	< 0.1%
11823.78	1	< 0.1%
11476.29	1	< 0.1%
9892.94	1	< 0.1%
9183.17	1	< 0.1%

GroundFloorArea(sq m)
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	43116
Distinct (%)	4.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	114.0114127

Minimum	5.47
Maximum	3546.11
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.0 MiB

Quantile statistics

Minimum	5.47
5-th percentile	47.71
Q1	77.92
median	100.3
Q3	133.71
95-th percentile	229.43
Maximum	3546.11
Range	3540.64
Interquartile range (IQR)	55.79

Descriptive statistics

Standard deviation	59.76115294
Coefficient of variation (CV)	0.5241681647
Kurtosis	36.34048694
Mean	114.0114127
Median Absolute Deviation (MAD)	26.12
Skewness	2.837078414
Sum	119017653.8
Variance	3571.395401
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
81	1374	0.1%
80	1191	0.1%
90	1050	0.1%
84	1022	0.1%
82	995	0.1%
85	846	0.1%
78	840	0.1%
88	815	0.1%
70	807	0.1%
108	754	0.1%
Other values (43106)	1034216	99.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5.47	1	< 0.1%
6.7	1	< 0.1%
7.21	1	< 0.1%
7.26	1	< 0.1%
7.47	1	< 0.1%
7.7	1	< 0.1%
7.91	1	< 0.1%
7.96	1	< 0.1%
8.3	1	< 0.1%
8.31	1	< 0.1%

Value	Count	Frequency (%)
3546.11	1	< 0.1%
3229.39	1	< 0.1%
2331.92	1	< 0.1%
2011.25	1	< 0.1%
1825.99	1	< 0.1%
1788.6	1	< 0.1%
1705.02	1	< 0.1%
1625.34	1	< 0.1%
1593	1	< 0.1%
1572.51	1	< 0.1%

CO2Rating
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	29109
Distinct (%)	2.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	54.55772451

Minimum	-258.25
Maximum	18417.1
Zeros	1
Zeros (%)	< 0.1%
Negative	210
Negative (%)	< 0.1%
Memory size	8.0 MiB

Quantile statistics

Minimum	-258.25
5-th percentile	9.43
Q1	32.46
median	46.25
Q3	65.13
95-th percentile	123.22
Maximum	18417.1
Range	18675.35
Interquartile range (IQR)	32.67

Descriptive statistics

Standard deviation	48.59638706
Coefficient of variation (CV)	0.8907333929
Kurtosis	21972.23116
Mean	54.55772451
Median Absolute Deviation (MAD)	15.71
Skewness	68.08527183
Sum	56953354.19
Variance	2361.608835
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9.69	282	< 0.1%
10.68	281	< 0.1%
9.43	277	< 0.1%
9.56	274	< 0.1%
10.1	273	< 0.1%
10.37	269	< 0.1%
10.21	263	< 0.1%
9.42	262	< 0.1%
9.64	257	< 0.1%
9.35	257	< 0.1%
Other values (29099)	1041215	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-258.25	1	< 0.1%
-88.57	1	< 0.1%
-27.98	1	< 0.1%
-23.82	1	< 0.1%
-20.25	1	< 0.1%
-17.51	1	< 0.1%
-16.02	1	< 0.1%
-14.49	1	< 0.1%
-13.67	1	< 0.1%
-13.09	1	< 0.1%

Value	Count	Frequency (%)
18417.1	1	< 0.1%
10541	1	< 0.1%
5840.25	1	< 0.1%
4019.2	1	< 0.1%
3467.31	1	< 0.1%
3327.24	1	< 0.1%
3283.77	1	< 0.1%
2822.29	1	< 0.1%
2817.23	1	< 0.1%
2760.17	1	< 0.1%

MainSpaceHeatingFuel
Categorical

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	20
Distinct (%)	< 0.1%
Missing	15648
Missing (%)	1.5%
Memory size	85.8 MiB

Mains Gas	399479
Heating Oil	367174
Electricity	200464
Solid Multi-Fuel	31706
Bulk LPG (propane or butane)	14346
Other values (15)	15093

Length

Max length	30
Median length	30
Mean length	30
Min length	30

Characters and Unicode

Total characters	30847860
Distinct characters	42
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Heating Oil
2nd row	Heating Oil
3rd row	Mains Gas
4th row	Mains Gas
5th row	Mains Gas

Common Values

Value	Count	Frequency (%)
Mains Gas	399479	38.3%
Heating Oil	367174	35.2%
Electricity	200464	19.2%
Solid Multi-Fuel	31706	3.0%
Bulk LPG (propane or butane)	14346	1.4%
Manufactured Smokeless Fuel	6714	0.6%
House Coal	3180	0.3%
Wood Pellets (bulk supply for	1480	0.1%
Sod Peat	1240	0.1%
Bottled LPG	1109	0.1%
Other values (10)	1370	0.1%
(Missing)	15648	1.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
mains	399479	20.9%
gas	399479	20.9%
heating	367174	19.2%
oil	367174	19.2%
electricity	200560	10.5%
solid	31706	1.7%
multi-fuel	31706	1.7%
bulk	15826	0.8%
lpg	15455	0.8%
butane	14346	0.8%
Other values (34)	68321	3.6%

Most occurring characters

Value	Count	Frequency (%)
	20683808	67.1%
i	1599064	5.2%
a	1213361	3.9%
t	827289	2.7%
s	820201	2.7%
n	802377	2.6%
l	701261	2.3%
e	665106	2.2%
M	437899	1.4%
G	414934	1.3%
Other values (32)	2682560	8.7%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	20683808	67.1%
Lowercase Letter	8176284	26.5%
Uppercase Letter	1925476	6.2%
Dash Punctuation	31912	0.1%
Open Punctuation	16034	0.1%
Close Punctuation	14346	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	1599064	19.6%
a	1213361	14.8%
t	827289	10.1%
s	820201	10.0%
n	802377	9.8%
l	701261	8.6%
e	665106	8.1%
c	408106	5.0%
g	368106	4.5%
r	238045	2.9%
Other values (12)	533368	6.5%

Uppercase Letter

Value	Count	Frequency (%)
M	437899	22.7%
G	414934	21.5%
H	370354	19.2%
O	367229	19.1%
E	200560	10.4%
S	39701	2.1%
F	38420	2.0%
P	18658	1.0%
L	16124	0.8%
B	15735	0.8%
Other values (6)	5862	0.3%

Space Separator

Value	Count	Frequency (%)
	20683808	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	31912	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	16034	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	14346	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	20746100	67.3%
Latin	10101760	32.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	1599064	15.8%
a	1213361	12.0%
t	827289	8.2%
s	820201	8.1%
n	802377	7.9%
l	701261	6.9%
e	665106	6.6%
M	437899	4.3%
G	414934	4.1%
c	408106	4.0%
Other values (28)	2212162	21.9%

Common

Value	Count	Frequency (%)
	20683808	99.7%
-	31912	0.2%
(	16034	0.1%
)	14346	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	30847860	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	20683808	67.1%
i	1599064	5.2%
a	1213361	3.9%
t	827289	2.7%
s	820201	2.7%
n	802377	2.6%
l	701261	2.3%
e	665106	2.2%
M	437899	1.4%
G	414934	1.3%
Other values (32)	2682560	8.7%

MainWaterHeatingFuel
Categorical

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	21
Distinct (%)	< 0.1%
Missing	15648
Missing (%)	1.5%
Memory size	85.8 MiB

Mains Gas	397437
Heating Oil	364085
Electricity	208906
Solid Multi-Fuel	29558
Bulk LPG (propane or butane)	14286
Other values (16)	13990

Length

Max length	30
Median length	30
Mean length	30
Min length	30

Characters and Unicode

Total characters	30847860
Distinct characters	42
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Heating Oil
2nd row	Heating Oil
3rd row	Mains Gas
4th row	Mains Gas
5th row	Mains Gas

Common Values

Value	Count	Frequency (%)
Mains Gas	397437	38.1%
Heating Oil	364085	34.9%
Electricity	208906	20.0%
Solid Multi-Fuel	29558	2.8%
Bulk LPG (propane or butane)	14286	1.4%
Manufactured Smokeless Fuel	5700	0.5%
House Coal	3022	0.3%
Wood Pellets (bulk supply for	1429	0.1%
Sod Peat	1262	0.1%
Bottled LPG	1216	0.1%
Other values (11)	1361	0.1%
(Missing)	15648	1.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
mains	397437	20.9%
gas	397437	20.9%
heating	364085	19.1%
oil	364085	19.1%
electricity	209003	11.0%
solid	29558	1.6%
multi-fuel	29558	1.6%
bulk	15715	0.8%
lpg	15502	0.8%
butane	14286	0.8%
Other values (35)	64822	3.4%

Most occurring characters

Value	Count	Frequency (%)
	20698285	67.1%
i	1603491	5.2%
a	1203962	3.9%
t	838113	2.7%
s	813842	2.6%
n	796173	2.6%
l	697872	2.3%
e	664097	2.2%
M	432695	1.4%
c	424015	1.4%
Other values (32)	2675315	8.7%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	20698285	67.1%
Lowercase Letter	8175690	26.5%
Uppercase Letter	1913924	6.2%
Dash Punctuation	29739	0.1%
Open Punctuation	15936	0.1%
Close Punctuation	14286	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	1603491	19.6%
a	1203962	14.7%
t	838113	10.3%
s	813842	10.0%
n	796173	9.7%
l	697872	8.5%
e	664097	8.1%
c	424015	5.2%
g	364954	4.5%
r	245374	3.0%
Other values (12)	523797	6.4%

Uppercase Letter

Value	Count	Frequency (%)
M	432695	22.6%
G	412939	21.6%
H	367107	19.2%
O	364127	19.0%
E	209003	10.9%
S	36575	1.9%
F	35258	1.8%
P	18686	1.0%
L	16108	0.8%
B	15788	0.8%
Other values (6)	5638	0.3%

Space Separator

Value	Count	Frequency (%)
	20698285	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	29739	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	15936	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	14286	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	20758246	67.3%
Latin	10089614	32.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	1603491	15.9%
a	1203962	11.9%
t	838113	8.3%
s	813842	8.1%
n	796173	7.9%
l	697872	6.9%
e	664097	6.6%
M	432695	4.3%
c	424015	4.2%
G	412939	4.1%
Other values (28)	2202415	21.8%

Common

Value	Count	Frequency (%)
	20698285	99.7%
-	29739	0.1%
(	15936	0.1%
)	14286	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	30847860	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	20698285	67.1%
i	1603491	5.2%
a	1203962	3.9%
t	838113	2.7%
s	813842	2.6%
n	796173	2.6%
l	697872	2.3%
e	664097	2.2%
M	432695	1.4%
c	424015	1.4%
Other values (32)	2675315	8.7%

VentilationMethod
Categorical

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	3613
Missing (%)	0.3%
Memory size	70.5 MiB

Natural vent.	967791
Whole house extract vent.	36357
Bal.whole mech.vent heat recvr	33861
Pos input vent.- loft	1406
Bal.whole mech.vent no heat re	445

Length

Max length	30
Median length	13
Mean length	13.99542823
Min length	13

Characters and Unicode

Total characters	14559402
Distinct characters	26
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Natural vent.
2nd row	Natural vent.
3rd row	Natural vent.
4th row	Natural vent.
5th row	Natural vent.

Common Values

Value	Count	Frequency (%)
Natural vent.	967791	92.7%
Whole house extract vent.	36357	3.5%
Bal.whole mech.vent heat recvr	33861	3.2%
Pos input vent.- loft	1406	0.1%
Bal.whole mech.vent no heat re	445	< 0.1%
Pos input vent.- outside	437	< 0.1%
(Missing)	3613	0.3%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
vent	1005991	45.2%
natural	967791	43.5%
whole	36357	1.6%
house	36357	1.6%
extract	36357	1.6%
bal.whole	34306	1.5%
mech.vent	34306	1.5%
heat	34306	1.5%
recvr	33861	1.5%
pos	1843	0.1%
Other values (5)	4576	0.2%

Most occurring characters

Value	Count	Frequency (%)
t	2118794	14.6%
a	2040551	14.0%
e	1287029	8.8%
	1185754	8.1%
.	1074603	7.4%
l	1074166	7.4%
v	1074158	7.4%
r	1072315	7.4%
n	1042585	7.2%
u	1006428	6.9%
Other values (16)	1583019	10.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	11256905	77.3%
Space Separator	1185754	8.1%
Other Punctuation	1074603	7.4%
Uppercase Letter	1040297	7.1%
Dash Punctuation	1843	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	2118794	18.8%
a	2040551	18.1%
e	1287029	11.4%
l	1074166	9.5%
v	1074158	9.5%
r	1072315	9.5%
n	1042585	9.3%
u	1006428	8.9%
h	175632	1.6%
o	111151	1.0%
Other values (9)	254096	2.3%

Uppercase Letter

Value	Count	Frequency (%)
N	967791	93.0%
W	36357	3.5%
B	34306	3.3%
P	1843	0.2%

Space Separator

Value	Count	Frequency (%)
	1185754	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	1074603	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1843	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	12297202	84.5%
Common	2262200	15.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	2118794	17.2%
a	2040551	16.6%
e	1287029	10.5%
l	1074166	8.7%
v	1074158	8.7%
r	1072315	8.7%
n	1042585	8.5%
u	1006428	8.2%
N	967791	7.9%
h	175632	1.4%
Other values (13)	437753	3.6%

Common

Value	Count	Frequency (%)
	1185754	52.4%
.	1074603	47.5%
-	1843	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	14559402	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	2118794	14.6%
a	2040551	14.0%
e	1287029	8.8%
	1185754	8.1%
.	1074603	7.4%
l	1074166	7.4%
v	1074158	7.4%
r	1072315	7.4%
n	1042585	7.2%
u	1006428	6.9%
Other values (16)	1583019	10.9%

StructureType
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	3613
Missing (%)	0.3%
Memory size	86.4 MiB

Masonry	888076
Please select	82498
Timber or Steel Frame	62959
Insulated Conctete Form	6764

Length

Max length	30
Median length	30
Mean length	30
Min length	30

Characters and Unicode

Total characters	31208910
Distinct characters	23
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Masonry
2nd row	Masonry
3rd row	Masonry
4th row	Masonry
5th row	Masonry

Common Values

Value	Count	Frequency (%)
Masonry	888076	85.1%
Please select	82498	7.9%
Timber or Steel Frame	62959	6.0%
Insulated Conctete Form	6764	0.6%
(Missing)	3613	0.3%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
masonry	888076	67.0%
please	82498	6.2%
select	82498	6.2%
timber	62959	4.8%
or	62959	4.8%
steel	62959	4.8%
frame	62959	4.8%
insulated	6764	0.5%
conctete	6764	0.5%
form	6764	0.5%

Most occurring characters

Value	Count	Frequency (%)
	22727096	72.8%
r	1083717	3.5%
s	1059836	3.4%
a	1040297	3.3%
o	964563	3.1%
n	901604	2.9%
M	888076	2.8%
y	888076	2.8%
e	602120	1.9%
l	234719	0.8%
Other values (13)	818806	2.6%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	22727096	72.8%
Lowercase Letter	7302071	23.4%
Uppercase Letter	1179743	3.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	1083717	14.8%
s	1059836	14.5%
a	1040297	14.2%
o	964563	13.2%
n	901604	12.3%
y	888076	12.2%
e	602120	8.2%
l	234719	3.2%
t	165749	2.3%
m	132682	1.8%
Other values (5)	228708	3.1%

Uppercase Letter

Value	Count	Frequency (%)
M	888076	75.3%
P	82498	7.0%
F	69723	5.9%
T	62959	5.3%
S	62959	5.3%
I	6764	0.6%
C	6764	0.6%

Space Separator

Value	Count	Frequency (%)
	22727096	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	22727096	72.8%
Latin	8481814	27.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	1083717	12.8%
s	1059836	12.5%
a	1040297	12.3%
o	964563	11.4%
n	901604	10.6%
M	888076	10.5%
y	888076	10.5%
e	602120	7.1%
l	234719	2.8%
t	165749	2.0%
Other values (12)	653057	7.7%

Common

Value	Count	Frequency (%)
	22727096	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	31208910	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	22727096	72.8%
r	1083717	3.5%
s	1059836	3.4%
a	1040297	3.3%
o	964563	3.1%
n	901604	2.9%
M	888076	2.8%
y	888076	2.8%
e	602120	1.9%
l	234719	0.8%
Other values (13)	818806	2.6%

NoOfSidesSheltered
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	3613
Missing (%)	0.3%
Memory size	59.7 MiB

2.0	427184
3.0	283384
4.0	144520
1.0	120592
0.0	64617

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	3120891
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	2.0
3rd row	3.0
4th row	2.0
5th row	2.0

Common Values

Value	Count	Frequency (%)
2.0	427184	40.9%
3.0	283384	27.1%
4.0	144520	13.8%
1.0	120592	11.6%
0.0	64617	6.2%
(Missing)	3613	0.3%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
2.0	427184	41.1%
3.0	283384	27.2%
4.0	144520	13.9%
1.0	120592	11.6%
0.0	64617	6.2%

Most occurring characters

Value	Count	Frequency (%)
0	1104914	35.4%
.	1040297	33.3%
2	427184	13.7%
3	283384	9.1%
4	144520	4.6%
1	120592	3.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2080594	66.7%
Other Punctuation	1040297	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1104914	53.1%
2	427184	20.5%
3	283384	13.6%
4	144520	6.9%
1	120592	5.8%

Other Punctuation

Value	Count	Frequency (%)
.	1040297	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3120891	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1104914	35.4%
.	1040297	33.3%
2	427184	13.7%
3	283384	9.1%
4	144520	4.6%
1	120592	3.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3120891	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1104914	35.4%
.	1040297	33.3%
2	427184	13.7%
3	283384	9.1%
4	144520	4.6%
1	120592	3.9%

InsulationType
Categorical

HIGH CORRELATION
MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	232787
Missing (%)	22.3%
Memory size	74.4 MiB

Factory Insulated	515548
Loose Jacket	199203
None	96372

Length

Max length	30
Median length	30
Mean length	30
Min length	30

Characters and Unicode

Total characters	24333690
Distinct characters	19
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Factory Insulated
2nd row	Factory Insulated
3rd row	Loose Jacket
4th row	Loose Jacket
5th row	Factory Insulated

Common Values

Value	Count	Frequency (%)
Factory Insulated	515548	49.4%
Loose Jacket	199203	19.1%
None	96372	9.2%
(Missing)	232787	22.3%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
factory	515548	33.8%
insulated	515548	33.8%
loose	199203	13.1%
jacket	199203	13.1%
none	96372	6.3%

Most occurring characters

Value	Count	Frequency (%)
	13508201	55.5%
t	1230299	5.1%
a	1230299	5.1%
o	1010326	4.2%
e	1010326	4.2%
c	714751	2.9%
s	714751	2.9%
n	611920	2.5%
u	515548	2.1%
d	515548	2.1%
Other values (9)	3271721	13.4%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	13508201	55.5%
Lowercase Letter	9299615	38.2%
Uppercase Letter	1525874	6.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	1230299	13.2%
a	1230299	13.2%
o	1010326	10.9%
e	1010326	10.9%
c	714751	7.7%
s	714751	7.7%
n	611920	6.6%
u	515548	5.5%
d	515548	5.5%
l	515548	5.5%
Other values (3)	1230299	13.2%

Uppercase Letter

Value	Count	Frequency (%)
F	515548	33.8%
I	515548	33.8%
L	199203	13.1%
J	199203	13.1%
N	96372	6.3%

Space Separator

Value	Count	Frequency (%)
	13508201	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	13508201	55.5%
Latin	10825489	44.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	1230299	11.4%
a	1230299	11.4%
o	1010326	9.3%
e	1010326	9.3%
c	714751	6.6%
s	714751	6.6%
n	611920	5.7%
u	515548	4.8%
d	515548	4.8%
l	515548	4.8%
Other values (8)	2756173	25.5%

Common

Value	Count	Frequency (%)
	13508201	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24333690	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	13508201	55.5%
t	1230299	5.1%
a	1230299	5.1%
o	1010326	4.2%
e	1010326	4.2%
c	714751	2.9%
s	714751	2.9%
n	611920	2.5%
u	515548	2.1%
d	515548	2.1%
Other values (9)	3271721	13.4%

InsulationThickness
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	183
Distinct (%)	< 0.1%
Missing	232787
Missing (%)	22.3%
Infinite	0
Infinite (%)	0.0%
Mean	31.62129622

Minimum	0
Maximum	1872
Zeros	128896
Zeros (%)	12.3%
Negative	0
Negative (%)	0.0%
Memory size	8.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	25
median	30
Q3	40
95-th percentile	75
Maximum	1872
Range	1872
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	23.80880348
Coefficient of variation (CV)	0.7529357212
Kurtosis	1384.949307
Mean	31.62129622
Median Absolute Deviation (MAD)	10
Skewness	19.06388138
Sum	25648760.65
Variance	566.8591229
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30	151255	14.5%
0	128896	12.3%
25	120261	11.5%
50	111547	10.7%
35	94791	9.1%
40	64568	6.2%
20	47566	4.6%
80	35009	3.4%
60	14649	1.4%
15	7859	0.8%
Other values (173)	34722	3.3%
(Missing)	232787	22.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	128896	12.3%
1	225	< 0.1%
1.752	1	< 0.1%
1.79	1	< 0.1%
1.89	2	< 0.1%
1.91	5	< 0.1%
1.92	1	< 0.1%
2	67	< 0.1%
2.33	1	< 0.1%
2.35	2	< 0.1%

Value	Count	Frequency (%)
1872	31	< 0.1%
890	1	< 0.1%
870	1	< 0.1%
801	1	< 0.1%
800	1	< 0.1%
670	2	< 0.1%
660	1	< 0.1%
600	4	< 0.1%
580	3	< 0.1%
560	1	< 0.1%

TotalDeliveredEnergy
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
SKEWED

Distinct	431412
Distinct (%)	96.8%
Missing	598110
Missing (%)	57.3%
Infinite	0
Infinite (%)	0.0%
Mean	24085.64042

Minimum	-3929.793
Maximum	5431169.676
Zeros	0
Zeros (%)	0.0%
Negative	3
Negative (%)	< 0.1%
Memory size	8.0 MiB

Quantile statistics

Minimum	-3929.793
5-th percentile	7979.789
Q1	14844.7955
median	21027.0305
Q3	29315.55175
95-th percentile	48890.06385
Maximum	5431169.676
Range	5435099.469
Interquartile range (IQR)	14470.75625

Descriptive statistics

Standard deviation	23306.37571
Coefficient of variation (CV)	0.9676460873
Kurtosis	14625.08005
Mean	24085.64042
Median Absolute Deviation (MAD)	6989.88
Skewness	87.22682973
Sum	1.07373785 × 10¹⁰
Variance	543187148.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11864.494	37	< 0.1%
6775.83	36	< 0.1%
11281.876	35	< 0.1%
9995.008	29	< 0.1%
184.697	27	< 0.1%
641.717	25	< 0.1%
105.592	25	< 0.1%
9139.246	25	< 0.1%
477.232	24	< 0.1%
13345.744	24	< 0.1%
Other values (431402)	445513	42.7%
(Missing)	598110	57.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-3929.793	1	< 0.1%
-2843.478	1	< 0.1%
-1805.047	1	< 0.1%
50.563	1	< 0.1%
56.181	1	< 0.1%
69.853	1	< 0.1%
72.877	1	< 0.1%
73.373	1	< 0.1%
74.998	1	< 0.1%
77.344	1	< 0.1%

Value	Count	Frequency (%)
5431169.676	1	< 0.1%
4129347.104	1	< 0.1%
3846582.646	1	< 0.1%
3444097.206	1	< 0.1%
3343274.743	1	< 0.1%
3133044.042	1	< 0.1%
2868451.102	1	< 0.1%
2844373.55	1	< 0.1%
2370104.193	1	< 0.1%
2050664.845	1	< 0.1%

DateOfAssessment
Categorical

HIGH CARDINALITY

Distinct	5282
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	75.7 MiB

Oct 31 2019 12:00AM	662
Jun 28 2022 12:00AM	628
Jun 27 2022 12:00AM	601
May 26 2022 12:00AM	589
Apr 28 2011 12:00AM	583
Other values (5277)	1040847

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	19834290
Distinct characters	34
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	90 ?
Unique (%)	< 0.1%

Sample

1st row	Oct 8 2010 12:00AM
2nd row	Oct 19 2010 12:00AM
3rd row	Oct 9 2010 12:00AM
4th row	Oct 20 2010 12:00AM
5th row	Oct 21 2010 12:00AM

Common Values

Value	Count	Frequency (%)
Oct 31 2019 12:00AM	662	0.1%
Jun 28 2022 12:00AM	628	0.1%
Jun 27 2022 12:00AM	601	0.1%
May 26 2022 12:00AM	589	0.1%
Apr 28 2011 12:00AM	583	0.1%
May 23 2022 12:00AM	577	0.1%
Mar 4 2015 12:00AM	566	0.1%
Jul 4 2022 12:00AM	560	0.1%
May 16 2022 12:00AM	559	0.1%
Oct 21 2021 12:00AM	555	0.1%
Other values (5272)	1038030	99.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
12:00am	1043910	25.0%
nov	97974	2.3%
oct	96504	2.3%
may	92206	2.2%
jun	91621	2.2%
mar	91208	2.2%
sep	90677	2.2%
2014	88313	2.1%
2019	87904	2.1%
jul	87543	2.1%
Other values (57)	2307780	55.3%

Most occurring characters

Value	Count	Frequency (%)
	3434822	17.3%
0	3426234	17.3%
2	2861040	14.4%
1	2448191	12.3%
M	1227324	6.2%
A	1207195	6.1%
:	1043910	5.3%
a	259752	1.3%
u	259367	1.3%
J	255502	1.3%
Other values (24)	3410953	17.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10136008	51.1%
Space Separator	3434822	17.3%
Uppercase Letter	3131730	15.8%
Lowercase Letter	2087820	10.5%
Other Punctuation	1043910	5.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	259752	12.4%
u	259367	12.4%
e	247231	11.8%
r	174290	8.3%
p	173759	8.3%
n	167959	8.0%
c	165854	7.9%
v	97974	4.7%
o	97974	4.7%
t	96504	4.6%
Other values (4)	347156	16.6%

Decimal Number

Value	Count	Frequency (%)
0	3426234	33.8%
2	2861040	28.2%
1	2448191	24.2%
9	245613	2.4%
3	231310	2.3%
4	192489	1.9%
8	187702	1.9%
7	182712	1.8%
5	181949	1.8%
6	178768	1.8%

Uppercase Letter

Value	Count	Frequency (%)
M	1227324	39.2%
A	1207195	38.5%
J	255502	8.2%
N	97974	3.1%
O	96504	3.1%
S	90677	2.9%
F	87204	2.8%
D	69350	2.2%

Space Separator

Value	Count	Frequency (%)
	3434822	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	1043910	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	14614740	73.7%
Latin	5219550	26.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
M	1227324	23.5%
A	1207195	23.1%
a	259752	5.0%
u	259367	5.0%
J	255502	4.9%
e	247231	4.7%
r	174290	3.3%
p	173759	3.3%
n	167959	3.2%
c	165854	3.2%
Other values (12)	1081317	20.7%

Common

Value	Count	Frequency (%)
	3434822	23.5%
0	3426234	23.4%
2	2861040	19.6%
1	2448191	16.8%
:	1043910	7.1%
9	245613	1.7%
3	231310	1.6%
4	192489	1.3%
8	187702	1.3%
7	182712	1.3%
Other values (2)	360717	2.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	19834290	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	3434822	17.3%
0	3426234	17.3%
2	2861040	14.4%
1	2448191	12.3%
M	1227324	6.2%
A	1207195	6.1%
:	1043910	5.3%
a	259752	1.3%
u	259367	1.3%
J	255502	1.3%
Other values (24)	3410953	17.2%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	CountyName	DwellingTypeDescr	YearofConstruction	EnergyRating	BerRating	GroundFloorArea(sq m)	CO2Rating	MainSpaceHeatingFuel	MainWaterHeatingFuel	VentilationMethod	StructureType	NoOfSidesSheltered	InsulationType	InsulationThickness	TotalDeliveredEnergy	DateOfAssessment
0	Co. Donegal	Detached house	1997	C2	180.01	171.19	45.53	Heating Oil	Heating Oil	Natural vent.	Masonry	1.00	Factory Insulated	20.00	25474.52	Oct 8 2010 12:00AM
1	Co. Kildare	Detached house	2010	B3	137.56	242.93	35.66	Heating Oil	Heating Oil	Natural vent.	Masonry	2.00	Factory Insulated	50.00	27654.47	Oct 19 2010 12:00AM
2	Co. Dublin	Semi-detached house	1999	C3	223.61	99.38	44.65	Mains Gas	Mains Gas	Natural vent.	Masonry	3.00	Loose Jacket	20.00	17000.04	Oct 9 2010 12:00AM
3	Dublin 11	Semi-detached house	1965	C2	196.99	138.41	37.83	Mains Gas	Mains Gas	Natural vent.	Masonry	2.00	NaN	NaN	22708.48	Oct 20 2010 12:00AM
4	Dublin 22	Semi-detached house	1985	D2	260.52	127.16	55.07	Mains Gas	Mains Gas	Natural vent.	Masonry	2.00	Loose Jacket	100.00	28182.86	Oct 21 2010 12:00AM
5	Co. Donegal	House	1975	D1	248.00	88.57	62.68	Heating Oil	Heating Oil	Natural vent.	Masonry	2.00	Factory Insulated	0.00	18470.03	Oct 16 2010 12:00AM
6	Dublin 22	Semi-detached house	1985	D2	275.97	73.54	58.21	Mains Gas	Mains Gas	Natural vent.	Masonry	2.00	Loose Jacket	100.00	17227.86	Oct 21 2010 12:00AM
7	Limerick City	Semi-detached house	1960	D1	244.71	89.54	59.79	Heating Oil	Heating Oil	Natural vent.	Masonry	3.00	Loose Jacket	80.00	16711.95	Oct 21 2010 12:00AM
8	Co. Kerry	House	1973	D2	293.82	157.62	71.30	Heating Oil	Heating Oil	Natural vent.	Masonry	1.00	Loose Jacket	50.00	40212.93	Oct 21 2010 12:00AM
9	Co. Kilkenny	Detached house	1980	D2	299.96	91.44	75.47	Heating Oil	Heating Oil	Natural vent.	Masonry	1.00	Loose Jacket	20.00	21839.38	Oct 20 2010 12:00AM

Last rows

	CountyName	DwellingTypeDescr	YearofConstruction	EnergyRating	BerRating	GroundFloorArea(sq m)	CO2Rating	MainSpaceHeatingFuel	MainWaterHeatingFuel	VentilationMethod	StructureType	NoOfSidesSheltered	InsulationType	InsulationThickness	TotalDeliveredEnergy	DateOfAssessment
1043900	Dublin 7	Top-floor apartment	2022	A2	46.90	77.00	8.82	NaN	NaN	Bal.whole mech.vent heat recvr	Masonry	2.00	NaN	NaN	NaN	Jun 28 2022 12:00AM
1043901	Co. Dublin	Ground-floor apartment	2004	D2	281.34	73.50	55.32	Electricity	Electricity	Natural vent.	Masonry	3.00	NaN	NaN	NaN	Jul 1 2022 12:00AM
1043902	Dublin 18	Mid-floor apartment	2020	A3	55.23	37.80	10.86	Electricity	Electricity	NaN	NaN	NaN	NaN	NaN	NaN	Jul 1 2022 12:00AM
1043903	Dublin 18	Mid-floor apartment	2020	A2	46.32	50.89	9.11	Electricity	Electricity	NaN	NaN	NaN	NaN	NaN	NaN	Jul 1 2022 12:00AM
1043904	Dublin 18	Mid-floor apartment	2020	A2	38.60	86.58	7.59	Electricity	Electricity	NaN	NaN	NaN	NaN	NaN	NaN	Jul 4 2022 12:00AM
1043905	Co. Donegal	Detached house	1982	D2	282.58	214.18	70.89	Heating Oil	Heating Oil	Natural vent.	Masonry	1.00	NaN	NaN	52927.53	Jun 25 2022 12:00AM
1043906	Dublin 6	Mid-terrace house	1900	G	998.14	99.77	317.99	Manufactured Smokeless Fuel	Electricity	Natural vent.	Masonry	4.00	NaN	NaN	NaN	Jul 6 2022 12:00AM
1043907	Dublin 1	Mid-floor apartment	2021	A2	37.26	81.32	7.33	NaN	NaN	Whole house extract vent.	Masonry	2.00	NaN	NaN	NaN	Dec 20 2021 12:00AM
1043908	Dublin 1	Mid-floor apartment	2022	A2	36.05	82.09	6.76	NaN	NaN	Bal.whole mech.vent heat recvr	Masonry	4.00	NaN	NaN	NaN	Jul 14 2022 12:00AM
1043909	Co. Monaghan	Detached house	2013	B1	90.57	334.35	19.66	Electricity	Electricity	Bal.whole mech.vent heat recvr	Timber or Steel Frame	1.00	NaN	NaN	NaN	Jul 15 2022 12:00AM

Most frequently occurring

	CountyName	DwellingTypeDescr	YearofConstruction	EnergyRating	BerRating	GroundFloorArea(sq m)	CO2Rating	MainSpaceHeatingFuel	MainWaterHeatingFuel	VentilationMethod	StructureType	NoOfSidesSheltered	InsulationType	InsulationThickness	TotalDeliveredEnergy	DateOfAssessment	# duplicates
1492	Co. Galway	Maisonette	2000	D2	299.11	83.60	71.23	Electricity	Electricity	Natural vent.	Masonry	3.00	Factory Insulated	40.00	11864.49	Jun 9 2009 12:00AM	37
675	Co. Cork	Semi-detached house	1995	G	476.80	29.91	113.55	Electricity	Electricity	Natural vent.	Masonry	2.00	Loose Jacket	25.00	6775.83	Apr 13 2011 12:00AM	36
1487	Co. Galway	Maisonette	2000	D2	272.41	87.40	64.87	Electricity	Electricity	Natural vent.	Masonry	3.00	Factory Insulated	40.00	11281.88	Jun 9 2009 12:00AM	35
3693	Co. Westmeath	Mid-terrace house	2008	B3	144.12	85.73	37.03	Heating Oil	Heating Oil	Natural vent.	Masonry	2.00	Factory Insulated	60.00	9995.01	Jun 2 2010 12:00AM	28
3337	Co. Sligo	Apartment	2004	D1	232.34	63.90	55.33	Electricity	Electricity	Natural vent.	Masonry	3.00	Factory Insulated	40.00	7051.80	Dec 20 2009 12:00AM	18
800	Co. Cork	Top-floor apartment	2006	C3	212.52	51.26	41.01	Mains Gas	Mains Gas	Natural vent.	Masonry	3.00	Factory Insulated	25.00	8974.92	May 5 2009 12:00AM	17
1619	Co. Galway	Top-floor apartment	2002	C3	223.53	103.50	53.23	Electricity	Electricity	Natural vent.	Masonry	2.00	Factory Insulated	40.00	10913.94	Sep 28 2009 12:00AM	17
270	Co. Cork	Apartment	2006	C1	154.50	120.19	30.06	Mains Gas	Mains Gas	Natural vent.	Masonry	3.00	Factory Insulated	25.00	15047.25	May 5 2009 12:00AM	16
1494	Co. Galway	Maisonette	2002	D2	263.95	109.50	62.86	Electricity	Electricity	Natural vent.	Masonry	3.00	Factory Insulated	40.00	13637.69	Sep 28 2009 12:00AM	16
4281	Dublin 11	Mid-terrace house	2000	C1	166.99	81.32	34.96	Mains Gas	Mains Gas	Natural vent.	Masonry	3.00	Factory Insulated	30.00	10655.74	Feb 20 2019 12:00AM	16

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Most occurring scripts